﻿CREATE TABLE [dbo].[codeTransactionResponse] (
    [TransactionResponseID] INT          IDENTITY (1, 1) NOT NULL,
    [ProcessorCode]         CHAR (1)     NOT NULL,
    [ResponseCode]          CHAR (6)     NOT NULL,
    [Description]           VARCHAR (60) NOT NULL,
    [Approved]              CHAR (1)     NOT NULL,
    [Retry]                 CHAR (1)     NOT NULL,
    [PaymentSystemID]       INT          NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Defines the response codes for money transactions', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeTransactionResponse';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The ID field', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeTransactionResponse', @level2type = N'COLUMN', @level2name = N'TransactionResponseID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The processor code.  Links to codePaymentProcessor table.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeTransactionResponse', @level2type = N'COLUMN', @level2name = N'ProcessorCode';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Response code.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeTransactionResponse', @level2type = N'COLUMN', @level2name = N'ResponseCode';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Definition for response code..', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeTransactionResponse', @level2type = N'COLUMN', @level2name = N'Description';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Indicates whether the ResponseCode means the transaction was approved (1), or not (0).', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeTransactionResponse', @level2type = N'COLUMN', @level2name = N'Approved';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Determines whether the transaction can be tried again (1), or not (0).', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeTransactionResponse', @level2type = N'COLUMN', @level2name = N'Retry';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The ID field from the codePaymentSystem', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeTransactionResponse', @level2type = N'COLUMN', @level2name = N'PaymentSystemID';

